DBA Data[Home] [Help]

APPS.ASO_COPY_QUOTE_PVT dependencies on FND_GLOBAL

Line 16: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

12: -- NOTE :
13: -- End of Comments
14:
15:
16: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
17: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
18: G_PKG_NAME CONSTANT VARCHAR2 ( 30 ) := 'ASO_COPY_QUOTE_PVT';
19: G_FILE_NAME CONSTANT VARCHAR2 ( 12 ) := 'asovcpyb.pls';
20:

Line 17: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

13: -- End of Comments
14:
15:
16: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
17: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
18: G_PKG_NAME CONSTANT VARCHAR2 ( 30 ) := 'ASO_COPY_QUOTE_PVT';
19: G_FILE_NAME CONSTANT VARCHAR2 ( 12 ) := 'asovcpyb.pls';
20:
21:

Line 106: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

102: l_qte_header_id NUMBER;
103: l_qte_status_id NUMBER;
104: l_dummy VARCHAR2 ( 2 );
105: lx_Price_Index_Link_Tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
106: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
107: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
108: X_New_Qte_Line_Id NUMBER;
109: -- hyang: for bug 2692785
110: lx_status VARCHAR2(1);

Line 107: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

103: l_qte_status_id NUMBER;
104: l_dummy VARCHAR2 ( 2 );
105: lx_Price_Index_Link_Tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
106: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
107: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
108: X_New_Qte_Line_Id NUMBER;
109: -- hyang: for bug 2692785
110: lx_status VARCHAR2(1);
111: l_copy_line_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

Line 250: IF FND_GLOBAL.User_Id IS NULL THEN

246: --
247: -- ******************************************************************
248: -- Validate Environment
249: -- ******************************************************************
250: IF FND_GLOBAL.User_Id IS NULL THEN
251: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
252: FND_MESSAGE.Set_Name ('ASO' , 'UT_CANNOT_GET_PROFILE_VALUE' );
253: FND_MESSAGE.Set_Token ('PROFILE' , 'USER_ID', FALSE );
254: FND_MSG_PUB.ADD;

Line 1094: p_last_updated_by => FND_Global.USER_ID ,

1090: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1091: x_return_status => x_return_status ,
1092: p_jtf_note_id => l_note_id ,
1093: p_last_update_date => sysdate ,
1094: p_last_updated_by => FND_Global.USER_ID ,
1095: p_creation_date => sysdate ,
1096: p_created_by => FND_Global.USER_ID ,
1097: p_last_update_login => FND_GLOBAL.LOGIN_ID ,
1098: p_note_context_type_id => x_qte_header_id ,

Line 1096: p_created_by => FND_Global.USER_ID ,

1092: p_jtf_note_id => l_note_id ,
1093: p_last_update_date => sysdate ,
1094: p_last_updated_by => FND_Global.USER_ID ,
1095: p_creation_date => sysdate ,
1096: p_created_by => FND_Global.USER_ID ,
1097: p_last_update_login => FND_GLOBAL.LOGIN_ID ,
1098: p_note_context_type_id => x_qte_header_id ,
1099: p_note_context_type => 'ASO_QUOTE' ,
1100: x_note_context_id => lx_jtf_note_context_id

Line 1097: p_last_update_login => FND_GLOBAL.LOGIN_ID ,

1093: p_last_update_date => sysdate ,
1094: p_last_updated_by => FND_Global.USER_ID ,
1095: p_creation_date => sysdate ,
1096: p_created_by => FND_Global.USER_ID ,
1097: p_last_update_login => FND_GLOBAL.LOGIN_ID ,
1098: p_note_context_type_id => x_qte_header_id ,
1099: p_note_context_type => 'ASO_QUOTE' ,
1100: x_note_context_id => lx_jtf_note_context_id
1101: );

Line 1929: || FND_GLOBAL.local_chr ( 45 )

1925: , p_new_object_id => x_qte_header_id
1926: , p_old_object_type_code => 'ASO_QUOTE'
1927: , p_new_object_type_code => 'ASO_QUOTE'
1928: , p_new_object_name => l_qte_header_rec.quote_number
1929: || FND_GLOBAL.local_chr ( 45 )
1930: || l_qte_header_rec.quote_version ,
1931: p_quote_version_flag => P_Copy_Quote_Control_Rec.New_Version
1932: );
1933: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 2395: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

2391: l_service_item_flag VARCHAR2 ( 1 );
2392: l_serviceable_product_flag VARCHAR2 ( 1 );
2393: l_return_status VARCHAR2 ( 1 );
2394: l_api_version_number CONSTANT NUMBER := 1.0;
2395: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
2396: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
2397: l_ship_id NUMBER;
2398: l_orig_item_id_tbl CZ_API_PUB.number_tbl_type;
2399: l_new_item_id_tbl CZ_API_PUB.number_tbl_type;

Line 2396: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

2392: l_serviceable_product_flag VARCHAR2 ( 1 );
2393: l_return_status VARCHAR2 ( 1 );
2394: l_api_version_number CONSTANT NUMBER := 1.0;
2395: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
2396: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
2397: l_ship_id NUMBER;
2398: l_orig_item_id_tbl CZ_API_PUB.number_tbl_type;
2399: l_new_item_id_tbl CZ_API_PUB.number_tbl_type;
2400: -- hyang: for bug 2692785

Line 5308: , P_created_by => FND_GLOBAL.USER_ID

5304: l_new_template_instance_id := NULL;
5305: ASO_SUP_TMPL_INSTANCE_PKG.INSERT_ROW (
5306: PX_ROWID => l_template_instance_rowid
5307: , PX_TEMPLATE_INSTANCE_ID => l_new_template_instance_id
5308: , P_created_by => FND_GLOBAL.USER_ID
5309: , P_creation_date => SYSDATE
5310: , P_last_updated_by => FND_GLOBAL.USER_ID
5311: , P_last_update_date => SYSDATE
5312: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID

Line 5310: , P_last_updated_by => FND_GLOBAL.USER_ID

5306: PX_ROWID => l_template_instance_rowid
5307: , PX_TEMPLATE_INSTANCE_ID => l_new_template_instance_id
5308: , P_created_by => FND_GLOBAL.USER_ID
5309: , P_creation_date => SYSDATE
5310: , P_last_updated_by => FND_GLOBAL.USER_ID
5311: , P_last_update_date => SYSDATE
5312: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
5313: , P_TEMPLATE_ID => template_val.template_id
5314: , P_Owner_Table_Name => 'ASO_QUOTE_HEADERS'

Line 5312: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID

5308: , P_created_by => FND_GLOBAL.USER_ID
5309: , P_creation_date => SYSDATE
5310: , P_last_updated_by => FND_GLOBAL.USER_ID
5311: , P_last_update_date => SYSDATE
5312: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
5313: , P_TEMPLATE_ID => template_val.template_id
5314: , P_Owner_Table_Name => 'ASO_QUOTE_HEADERS'
5315: , P_Owner_Table_Id => p_new_quote_header_id
5316: , P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

Line 5349: , P_created_by => FND_GLOBAL.USER_ID

5345: , P_Template_Instance_ID => l_new_template_instance_id
5346: , p_value => inst_val.VALUE
5347: , p_value_type_qualifier => inst_val.value_type_qualifier
5348: , p_response_id => inst_val.response_id
5349: , P_created_by => FND_GLOBAL.USER_ID
5350: , P_last_updated_by => FND_GLOBAL.USER_ID
5351: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
5352: , P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
5353: );

Line 5350: , P_last_updated_by => FND_GLOBAL.USER_ID

5346: , p_value => inst_val.VALUE
5347: , p_value_type_qualifier => inst_val.value_type_qualifier
5348: , p_response_id => inst_val.response_id
5349: , P_created_by => FND_GLOBAL.USER_ID
5350: , P_last_updated_by => FND_GLOBAL.USER_ID
5351: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
5352: , P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
5353: );
5354: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 5351: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID

5347: , p_value_type_qualifier => inst_val.value_type_qualifier
5348: , p_response_id => inst_val.response_id
5349: , P_created_by => FND_GLOBAL.USER_ID
5350: , P_last_updated_by => FND_GLOBAL.USER_ID
5351: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
5352: , P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
5353: );
5354: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5355: aso_debug_pub.ADD ( 'New Instance Value Id : ' || TO_CHAR ( l_instance_value_id ) , 1 , 'N' );

Line 5641: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

5637: := ASO_CFG_INT.G_MISS_Control_Rec;
5638: l_Copy_Quote_Control_Rec ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type;
5639: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
5640: LX_LINE_RELATIONSHIP_ID NUMBER;
5641: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
5642: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
5643: l_ship_id NUMBER;
5644: -- l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
5645: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;

Line 5642: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

5638: l_Copy_Quote_Control_Rec ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type;
5639: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
5640: LX_LINE_RELATIONSHIP_ID NUMBER;
5641: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
5642: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
5643: l_ship_id NUMBER;
5644: -- l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
5645: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
5646:

Line 6849: , P_created_by => FND_GLOBAL.USER_ID

6845: l_new_template_instance_id := NULL;
6846: ASO_SUP_TMPL_INSTANCE_PKG.INSERT_ROW (
6847: PX_ROWID => l_template_instance_rowid
6848: , PX_TEMPLATE_INSTANCE_ID => l_new_template_instance_id
6849: , P_created_by => FND_GLOBAL.USER_ID
6850: , P_creation_date => SYSDATE
6851: , P_last_updated_by => FND_GLOBAL.USER_ID
6852: , P_last_update_date => SYSDATE
6853: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID

Line 6851: , P_last_updated_by => FND_GLOBAL.USER_ID

6847: PX_ROWID => l_template_instance_rowid
6848: , PX_TEMPLATE_INSTANCE_ID => l_new_template_instance_id
6849: , P_created_by => FND_GLOBAL.USER_ID
6850: , P_creation_date => SYSDATE
6851: , P_last_updated_by => FND_GLOBAL.USER_ID
6852: , P_last_update_date => SYSDATE
6853: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
6854: , P_TEMPLATE_ID => template_val.template_id
6855: , P_Owner_Table_Name => 'ASO_QUOTE_LINES'

Line 6853: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID

6849: , P_created_by => FND_GLOBAL.USER_ID
6850: , P_creation_date => SYSDATE
6851: , P_last_updated_by => FND_GLOBAL.USER_ID
6852: , P_last_update_date => SYSDATE
6853: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
6854: , P_TEMPLATE_ID => template_val.template_id
6855: , P_Owner_Table_Name => 'ASO_QUOTE_LINES'
6856: , P_Owner_Table_Id => P_NEW_QUOTE_LINE_ID
6857: , P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM

Line 6891: , P_created_by => FND_GLOBAL.USER_ID

6887: , P_Template_Instance_ID => l_new_template_instance_id
6888: , p_value => inst_val.VALUE
6889: , p_value_type_qualifier => inst_val.value_type_qualifier
6890: , p_response_id => inst_val.response_id
6891: , P_created_by => FND_GLOBAL.USER_ID
6892: , P_last_updated_by => FND_GLOBAL.USER_ID
6893: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
6894: , P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
6895: );

Line 6892: , P_last_updated_by => FND_GLOBAL.USER_ID

6888: , p_value => inst_val.VALUE
6889: , p_value_type_qualifier => inst_val.value_type_qualifier
6890: , p_response_id => inst_val.response_id
6891: , P_created_by => FND_GLOBAL.USER_ID
6892: , P_last_updated_by => FND_GLOBAL.USER_ID
6893: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
6894: , P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
6895: );
6896: IF aso_debug_pub.g_debug_flag = 'Y' THEN

Line 6893: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID

6889: , p_value_type_qualifier => inst_val.value_type_qualifier
6890: , p_response_id => inst_val.response_id
6891: , P_created_by => FND_GLOBAL.USER_ID
6892: , P_last_updated_by => FND_GLOBAL.USER_ID
6893: , P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
6894: , P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
6895: );
6896: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6897: aso_debug_pub.ADD ( 'New Instance Value Id : ' || TO_CHAR ( l_instance_value_id ) , 1 , 'N' );

Line 7144: p_CREATED_BY => fnd_global.USER_ID,

7140:
7141: ASO_PAYMENTS_PKG.Insert_Row(
7142: px_PAYMENT_ID => l_payment_rec.PAYMENT_ID,
7143: p_CREATION_DATE => SYSDATE,
7144: p_CREATED_BY => fnd_global.USER_ID,
7145: p_LAST_UPDATE_DATE => SYSDATE,
7146: p_LAST_UPDATED_BY => fnd_global.USER_ID,
7147: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
7148: p_REQUEST_ID => l_payment_rec.REQUEST_ID,

Line 7146: p_LAST_UPDATED_BY => fnd_global.USER_ID,

7142: px_PAYMENT_ID => l_payment_rec.PAYMENT_ID,
7143: p_CREATION_DATE => SYSDATE,
7144: p_CREATED_BY => fnd_global.USER_ID,
7145: p_LAST_UPDATE_DATE => SYSDATE,
7146: p_LAST_UPDATED_BY => fnd_global.USER_ID,
7147: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
7148: p_REQUEST_ID => l_payment_rec.REQUEST_ID,
7149: p_PROGRAM_APPLICATION_ID => l_payment_rec.PROGRAM_APPLICATION_ID,
7150: p_PROGRAM_ID => l_payment_rec.PROGRAM_ID,

Line 7147: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,

7143: p_CREATION_DATE => SYSDATE,
7144: p_CREATED_BY => fnd_global.USER_ID,
7145: p_LAST_UPDATE_DATE => SYSDATE,
7146: p_LAST_UPDATED_BY => fnd_global.USER_ID,
7147: p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
7148: p_REQUEST_ID => l_payment_rec.REQUEST_ID,
7149: p_PROGRAM_APPLICATION_ID => l_payment_rec.PROGRAM_APPLICATION_ID,
7150: p_PROGRAM_ID => l_payment_rec.PROGRAM_ID,
7151: p_PROGRAM_UPDATE_DATE => l_payment_rec.PROGRAM_UPDATE_DATE,