eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_SALES_MEMBER_PUB dependencies on FND_API

Line 48: salesforce_id Number :=FND_API.G_MISS_NUM

44: G_PARTNER_SALES_MEMBER CONSTANT VARCHAR2(30) := 'PARTNER';
45: G_OTHER_SALES_MEMBER CONSTANT VARCHAR2(30) := 'OTHERS';
46:
47: TYPE sales_member_rec_type IS RECORD (
48: salesforce_id Number :=FND_API.G_MISS_NUM
49: ,Type Varchar2(30) :=FND_API.G_MISS_CHAR
50: ,Start_date_active DATE :=FND_API.G_MISS_DATE
51: ,End_date_active DATE :=FND_API.G_MISS_DATE
52: ,Employee_Person_Id Number :=FND_API.G_MISS_NUM

Line 49: ,Type Varchar2(30) :=FND_API.G_MISS_CHAR

45: G_OTHER_SALES_MEMBER CONSTANT VARCHAR2(30) := 'OTHERS';
46:
47: TYPE sales_member_rec_type IS RECORD (
48: salesforce_id Number :=FND_API.G_MISS_NUM
49: ,Type Varchar2(30) :=FND_API.G_MISS_CHAR
50: ,Start_date_active DATE :=FND_API.G_MISS_DATE
51: ,End_date_active DATE :=FND_API.G_MISS_DATE
52: ,Employee_Person_Id Number :=FND_API.G_MISS_NUM
53: ,Sales_Group_Id Number :=FND_API.G_MISS_NUM

Line 50: ,Start_date_active DATE :=FND_API.G_MISS_DATE

46:
47: TYPE sales_member_rec_type IS RECORD (
48: salesforce_id Number :=FND_API.G_MISS_NUM
49: ,Type Varchar2(30) :=FND_API.G_MISS_CHAR
50: ,Start_date_active DATE :=FND_API.G_MISS_DATE
51: ,End_date_active DATE :=FND_API.G_MISS_DATE
52: ,Employee_Person_Id Number :=FND_API.G_MISS_NUM
53: ,Sales_Group_Id Number :=FND_API.G_MISS_NUM
54: ,Partner_Address_Id Number :=FND_API.G_MISS_NUM

Line 51: ,End_date_active DATE :=FND_API.G_MISS_DATE

47: TYPE sales_member_rec_type IS RECORD (
48: salesforce_id Number :=FND_API.G_MISS_NUM
49: ,Type Varchar2(30) :=FND_API.G_MISS_CHAR
50: ,Start_date_active DATE :=FND_API.G_MISS_DATE
51: ,End_date_active DATE :=FND_API.G_MISS_DATE
52: ,Employee_Person_Id Number :=FND_API.G_MISS_NUM
53: ,Sales_Group_Id Number :=FND_API.G_MISS_NUM
54: ,Partner_Address_Id Number :=FND_API.G_MISS_NUM
55: ,Partner_Customer_Id Number :=FND_API.G_MISS_NUM

Line 52: ,Employee_Person_Id Number :=FND_API.G_MISS_NUM

48: salesforce_id Number :=FND_API.G_MISS_NUM
49: ,Type Varchar2(30) :=FND_API.G_MISS_CHAR
50: ,Start_date_active DATE :=FND_API.G_MISS_DATE
51: ,End_date_active DATE :=FND_API.G_MISS_DATE
52: ,Employee_Person_Id Number :=FND_API.G_MISS_NUM
53: ,Sales_Group_Id Number :=FND_API.G_MISS_NUM
54: ,Partner_Address_Id Number :=FND_API.G_MISS_NUM
55: ,Partner_Customer_Id Number :=FND_API.G_MISS_NUM
56: ,Partner_Contact_Id Number :=FND_API.G_MISS_NUM

Line 53: ,Sales_Group_Id Number :=FND_API.G_MISS_NUM

49: ,Type Varchar2(30) :=FND_API.G_MISS_CHAR
50: ,Start_date_active DATE :=FND_API.G_MISS_DATE
51: ,End_date_active DATE :=FND_API.G_MISS_DATE
52: ,Employee_Person_Id Number :=FND_API.G_MISS_NUM
53: ,Sales_Group_Id Number :=FND_API.G_MISS_NUM
54: ,Partner_Address_Id Number :=FND_API.G_MISS_NUM
55: ,Partner_Customer_Id Number :=FND_API.G_MISS_NUM
56: ,Partner_Contact_Id Number :=FND_API.G_MISS_NUM
57: ,Last_name Varchar2(40) :=FND_API.G_MISS_CHAR

Line 54: ,Partner_Address_Id Number :=FND_API.G_MISS_NUM

50: ,Start_date_active DATE :=FND_API.G_MISS_DATE
51: ,End_date_active DATE :=FND_API.G_MISS_DATE
52: ,Employee_Person_Id Number :=FND_API.G_MISS_NUM
53: ,Sales_Group_Id Number :=FND_API.G_MISS_NUM
54: ,Partner_Address_Id Number :=FND_API.G_MISS_NUM
55: ,Partner_Customer_Id Number :=FND_API.G_MISS_NUM
56: ,Partner_Contact_Id Number :=FND_API.G_MISS_NUM
57: ,Last_name Varchar2(40) :=FND_API.G_MISS_CHAR
58: ,First_name Varchar2(20) :=FND_API.G_MISS_CHAR

Line 55: ,Partner_Customer_Id Number :=FND_API.G_MISS_NUM

51: ,End_date_active DATE :=FND_API.G_MISS_DATE
52: ,Employee_Person_Id Number :=FND_API.G_MISS_NUM
53: ,Sales_Group_Id Number :=FND_API.G_MISS_NUM
54: ,Partner_Address_Id Number :=FND_API.G_MISS_NUM
55: ,Partner_Customer_Id Number :=FND_API.G_MISS_NUM
56: ,Partner_Contact_Id Number :=FND_API.G_MISS_NUM
57: ,Last_name Varchar2(40) :=FND_API.G_MISS_CHAR
58: ,First_name Varchar2(20) :=FND_API.G_MISS_CHAR
59: ,Full_name Varchar2(240) :=FND_API.G_MISS_CHAR

Line 56: ,Partner_Contact_Id Number :=FND_API.G_MISS_NUM

52: ,Employee_Person_Id Number :=FND_API.G_MISS_NUM
53: ,Sales_Group_Id Number :=FND_API.G_MISS_NUM
54: ,Partner_Address_Id Number :=FND_API.G_MISS_NUM
55: ,Partner_Customer_Id Number :=FND_API.G_MISS_NUM
56: ,Partner_Contact_Id Number :=FND_API.G_MISS_NUM
57: ,Last_name Varchar2(40) :=FND_API.G_MISS_CHAR
58: ,First_name Varchar2(20) :=FND_API.G_MISS_CHAR
59: ,Full_name Varchar2(240) :=FND_API.G_MISS_CHAR
60: ,Email_address Varchar2(240) :=FND_API.G_MISS_CHAR

Line 57: ,Last_name Varchar2(40) :=FND_API.G_MISS_CHAR

53: ,Sales_Group_Id Number :=FND_API.G_MISS_NUM
54: ,Partner_Address_Id Number :=FND_API.G_MISS_NUM
55: ,Partner_Customer_Id Number :=FND_API.G_MISS_NUM
56: ,Partner_Contact_Id Number :=FND_API.G_MISS_NUM
57: ,Last_name Varchar2(40) :=FND_API.G_MISS_CHAR
58: ,First_name Varchar2(20) :=FND_API.G_MISS_CHAR
59: ,Full_name Varchar2(240) :=FND_API.G_MISS_CHAR
60: ,Email_address Varchar2(240) :=FND_API.G_MISS_CHAR
61: ,Job_title Varchar2(240) :=FND_API.G_MISS_CHAR

Line 58: ,First_name Varchar2(20) :=FND_API.G_MISS_CHAR

54: ,Partner_Address_Id Number :=FND_API.G_MISS_NUM
55: ,Partner_Customer_Id Number :=FND_API.G_MISS_NUM
56: ,Partner_Contact_Id Number :=FND_API.G_MISS_NUM
57: ,Last_name Varchar2(40) :=FND_API.G_MISS_CHAR
58: ,First_name Varchar2(20) :=FND_API.G_MISS_CHAR
59: ,Full_name Varchar2(240) :=FND_API.G_MISS_CHAR
60: ,Email_address Varchar2(240) :=FND_API.G_MISS_CHAR
61: ,Job_title Varchar2(240) :=FND_API.G_MISS_CHAR
62: ,Sales_Group_Name Varchar2(60) :=FND_API.G_MISS_CHAR

Line 59: ,Full_name Varchar2(240) :=FND_API.G_MISS_CHAR

55: ,Partner_Customer_Id Number :=FND_API.G_MISS_NUM
56: ,Partner_Contact_Id Number :=FND_API.G_MISS_NUM
57: ,Last_name Varchar2(40) :=FND_API.G_MISS_CHAR
58: ,First_name Varchar2(20) :=FND_API.G_MISS_CHAR
59: ,Full_name Varchar2(240) :=FND_API.G_MISS_CHAR
60: ,Email_address Varchar2(240) :=FND_API.G_MISS_CHAR
61: ,Job_title Varchar2(240) :=FND_API.G_MISS_CHAR
62: ,Sales_Group_Name Varchar2(60) :=FND_API.G_MISS_CHAR
63: ,Customer_name Varchar2(50) :=FND_API.G_MISS_CHAR

Line 60: ,Email_address Varchar2(240) :=FND_API.G_MISS_CHAR

56: ,Partner_Contact_Id Number :=FND_API.G_MISS_NUM
57: ,Last_name Varchar2(40) :=FND_API.G_MISS_CHAR
58: ,First_name Varchar2(20) :=FND_API.G_MISS_CHAR
59: ,Full_name Varchar2(240) :=FND_API.G_MISS_CHAR
60: ,Email_address Varchar2(240) :=FND_API.G_MISS_CHAR
61: ,Job_title Varchar2(240) :=FND_API.G_MISS_CHAR
62: ,Sales_Group_Name Varchar2(60) :=FND_API.G_MISS_CHAR
63: ,Customer_name Varchar2(50) :=FND_API.G_MISS_CHAR
64: ,City Varchar2(60) :=FND_API.G_MISS_CHAR

Line 61: ,Job_title Varchar2(240) :=FND_API.G_MISS_CHAR

57: ,Last_name Varchar2(40) :=FND_API.G_MISS_CHAR
58: ,First_name Varchar2(20) :=FND_API.G_MISS_CHAR
59: ,Full_name Varchar2(240) :=FND_API.G_MISS_CHAR
60: ,Email_address Varchar2(240) :=FND_API.G_MISS_CHAR
61: ,Job_title Varchar2(240) :=FND_API.G_MISS_CHAR
62: ,Sales_Group_Name Varchar2(60) :=FND_API.G_MISS_CHAR
63: ,Customer_name Varchar2(50) :=FND_API.G_MISS_CHAR
64: ,City Varchar2(60) :=FND_API.G_MISS_CHAR
65: ,State Varchar2(60) :=FND_API.G_MISS_CHAR

Line 62: ,Sales_Group_Name Varchar2(60) :=FND_API.G_MISS_CHAR

58: ,First_name Varchar2(20) :=FND_API.G_MISS_CHAR
59: ,Full_name Varchar2(240) :=FND_API.G_MISS_CHAR
60: ,Email_address Varchar2(240) :=FND_API.G_MISS_CHAR
61: ,Job_title Varchar2(240) :=FND_API.G_MISS_CHAR
62: ,Sales_Group_Name Varchar2(60) :=FND_API.G_MISS_CHAR
63: ,Customer_name Varchar2(50) :=FND_API.G_MISS_CHAR
64: ,City Varchar2(60) :=FND_API.G_MISS_CHAR
65: ,State Varchar2(60) :=FND_API.G_MISS_CHAR
66: ,Address Varchar2(240) :=FND_API.G_MISS_CHAR

Line 63: ,Customer_name Varchar2(50) :=FND_API.G_MISS_CHAR

59: ,Full_name Varchar2(240) :=FND_API.G_MISS_CHAR
60: ,Email_address Varchar2(240) :=FND_API.G_MISS_CHAR
61: ,Job_title Varchar2(240) :=FND_API.G_MISS_CHAR
62: ,Sales_Group_Name Varchar2(60) :=FND_API.G_MISS_CHAR
63: ,Customer_name Varchar2(50) :=FND_API.G_MISS_CHAR
64: ,City Varchar2(60) :=FND_API.G_MISS_CHAR
65: ,State Varchar2(60) :=FND_API.G_MISS_CHAR
66: ,Address Varchar2(240) :=FND_API.G_MISS_CHAR
67: ,user_id Number :=FND_API.G_MISS_NUM

Line 64: ,City Varchar2(60) :=FND_API.G_MISS_CHAR

60: ,Email_address Varchar2(240) :=FND_API.G_MISS_CHAR
61: ,Job_title Varchar2(240) :=FND_API.G_MISS_CHAR
62: ,Sales_Group_Name Varchar2(60) :=FND_API.G_MISS_CHAR
63: ,Customer_name Varchar2(50) :=FND_API.G_MISS_CHAR
64: ,City Varchar2(60) :=FND_API.G_MISS_CHAR
65: ,State Varchar2(60) :=FND_API.G_MISS_CHAR
66: ,Address Varchar2(240) :=FND_API.G_MISS_CHAR
67: ,user_id Number :=FND_API.G_MISS_NUM
68: ,managing_sales_grp_id Number :=FND_API.G_MISS_NUM

Line 65: ,State Varchar2(60) :=FND_API.G_MISS_CHAR

61: ,Job_title Varchar2(240) :=FND_API.G_MISS_CHAR
62: ,Sales_Group_Name Varchar2(60) :=FND_API.G_MISS_CHAR
63: ,Customer_name Varchar2(50) :=FND_API.G_MISS_CHAR
64: ,City Varchar2(60) :=FND_API.G_MISS_CHAR
65: ,State Varchar2(60) :=FND_API.G_MISS_CHAR
66: ,Address Varchar2(240) :=FND_API.G_MISS_CHAR
67: ,user_id Number :=FND_API.G_MISS_NUM
68: ,managing_sales_grp_id Number :=FND_API.G_MISS_NUM
69: ,managing_sales_grp_name Varchar2(60) :=FND_API.G_MISS_CHAR

Line 66: ,Address Varchar2(240) :=FND_API.G_MISS_CHAR

62: ,Sales_Group_Name Varchar2(60) :=FND_API.G_MISS_CHAR
63: ,Customer_name Varchar2(50) :=FND_API.G_MISS_CHAR
64: ,City Varchar2(60) :=FND_API.G_MISS_CHAR
65: ,State Varchar2(60) :=FND_API.G_MISS_CHAR
66: ,Address Varchar2(240) :=FND_API.G_MISS_CHAR
67: ,user_id Number :=FND_API.G_MISS_NUM
68: ,managing_sales_grp_id Number :=FND_API.G_MISS_NUM
69: ,managing_sales_grp_name Varchar2(60) :=FND_API.G_MISS_CHAR
70: );

Line 67: ,user_id Number :=FND_API.G_MISS_NUM

63: ,Customer_name Varchar2(50) :=FND_API.G_MISS_CHAR
64: ,City Varchar2(60) :=FND_API.G_MISS_CHAR
65: ,State Varchar2(60) :=FND_API.G_MISS_CHAR
66: ,Address Varchar2(240) :=FND_API.G_MISS_CHAR
67: ,user_id Number :=FND_API.G_MISS_NUM
68: ,managing_sales_grp_id Number :=FND_API.G_MISS_NUM
69: ,managing_sales_grp_name Varchar2(60) :=FND_API.G_MISS_CHAR
70: );
71:

Line 68: ,managing_sales_grp_id Number :=FND_API.G_MISS_NUM

64: ,City Varchar2(60) :=FND_API.G_MISS_CHAR
65: ,State Varchar2(60) :=FND_API.G_MISS_CHAR
66: ,Address Varchar2(240) :=FND_API.G_MISS_CHAR
67: ,user_id Number :=FND_API.G_MISS_NUM
68: ,managing_sales_grp_id Number :=FND_API.G_MISS_NUM
69: ,managing_sales_grp_name Varchar2(60) :=FND_API.G_MISS_CHAR
70: );
71:
72: G_MISS_SALES_MEMBER_REC sales_member_rec_type;

Line 69: ,managing_sales_grp_name Varchar2(60) :=FND_API.G_MISS_CHAR

65: ,State Varchar2(60) :=FND_API.G_MISS_CHAR
66: ,Address Varchar2(240) :=FND_API.G_MISS_CHAR
67: ,user_id Number :=FND_API.G_MISS_NUM
68: ,managing_sales_grp_id Number :=FND_API.G_MISS_NUM
69: ,managing_sales_grp_name Varchar2(60) :=FND_API.G_MISS_CHAR
70: );
71:
72: G_MISS_SALES_MEMBER_REC sales_member_rec_type;
73:

Line 91: -- Default = :=FND_API.G_FALSE

87: -- IN :
88: -- p_api_version_number IN NUMBER Required
89: -- p_identity_salesforce_id IN NUMBER Required
90: -- p_init_msg_list IN VARCHAR2 Optional
91: -- Default = :=FND_API.G_FALSE
92: --
93: -- OUT NOCOPY /* file.sql.39 change */ :
94: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
95: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 111: := FND_API.G_FALSE,

107:
108: PROCEDURE Convert_SFID_to_Values
109: ( p_api_version_number IN NUMBER,
110: p_init_msg_list IN VARCHAR2
111: := FND_API.G_FALSE,
112: p_salesforce_id IN NUMBER,
113:
114: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
115: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 135: -- Default = :=FND_API.G_FALSE

131: -- p_api_version_number IN NUMBER Required
132: -- p_partner_customer_id IN NUMBER Required
133: -- p_partner_address_id IN NUMBER Required
134: -- p_init_msg_list IN VARCHAR2 Optional
135: -- Default = :=FND_API.G_FALSE
136: --
137: -- OUT NOCOPY /* file.sql.39 change */ :
138: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
139: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 151: := FND_API.G_FALSE

147: -- Notes:
148:
149: Procedure Convert_Partner_to_ID( p_api_version_number IN NUMBER
150: ,p_init_msg_list IN VARCHAR2
151: := FND_API.G_FALSE
152: ,p_partner_customer_id IN Number
153: ,p_partner_address_id IN Number
154: ,x_return_status OUT NOCOPY /* file.sql.39 change */ Varchar2
155: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER