[Home] [Help]
470:
471: TYPE party_site_tbl_type IS TABLE OF party_site_rec_type INDEX BY BINARY_INTEGER;
472: -- added the following procedure for contact creation oct 2004
473: PROCEDURE create_person (
474: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
475: p_person_tbl IN PERSON_TBL_TYPE,
476: x_party_id OUT NOCOPY NUMBER,
477: x_party_number OUT NOCOPY VARCHAR2,
478: x_profile_id OUT NOCOPY NUMBER,
481: x_msg_data OUT NOCOPY VARCHAR2
482: );
483:
484: PROCEDURE update_person (
485: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
486: p_person_tbl IN PERSON_TBL_TYPE,
487: p_party_object_version_number IN NUMBER,
488: x_profile_id OUT NOCOPY NUMBER,
489: x_return_status OUT NOCOPY VARCHAR2,
491: x_msg_data OUT NOCOPY VARCHAR2
492: );
493:
494: PROCEDURE create_org_contact (
495: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
496: p_org_contact_tbl IN ORG_CONTACT_TBL_TYPE,
497: p_relationship_tbl_type IN relationship_tbl_type,
498: x_org_contact_id OUT NOCOPY NUMBER,
499: x_party_rel_id OUT NOCOPY NUMBER,
504: x_msg_data OUT NOCOPY VARCHAR2
505: );
506:
507: PROCEDURE update_org_contact (
508: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
509: p_org_contact_tbl IN ORG_CONTACT_TBL_TYPE,
510: p_relationship_tbl_type IN relationship_tbl_type,
511: p_cont_object_version_number IN OUT NOCOPY NUMBER,
512: p_rel_object_version_number IN OUT NOCOPY NUMBER,
516: x_msg_data OUT NOCOPY VARCHAR2
517: );
518:
519: PROCEDURE create_party_site (
520: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
521: p_party_site_tbl IN PARTY_SITE_TBL_TYPE,
522: x_party_site_id OUT NOCOPY NUMBER,
523: x_party_site_number OUT NOCOPY VARCHAR2,
524: x_return_status OUT NOCOPY VARCHAR2,
526: x_msg_data OUT NOCOPY VARCHAR2
527: );
528:
529: PROCEDURE update_party_site (
530: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
531: p_party_site_tbl IN PARTY_SITE_TBL_TYPE,
532: p_object_version_number IN OUT NOCOPY NUMBER,
533: x_return_status OUT NOCOPY VARCHAR2,
534: x_msg_count OUT NOCOPY NUMBER,
535: x_msg_data OUT NOCOPY VARCHAR2
536: );
537:
538: PROCEDURE create_cust_account_role (
539: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
540: p_cust_account_role_tbl IN CUST_ACCOUNT_ROLE_tbl_TYPE,
541: x_cust_account_role_id OUT NOCOPY NUMBER,
542: x_return_status OUT NOCOPY VARCHAR2,
543: x_msg_count OUT NOCOPY NUMBER,
544: x_msg_data OUT NOCOPY VARCHAR2
545: ) ;
546:
547: PROCEDURE update_cust_account_role (
548: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
549: p_cust_account_role_tbl IN CUST_ACCOUNT_ROLE_tbl_TYPE,
550: p_object_version_number IN OUT NOCOPY NUMBER,
551: x_return_status OUT NOCOPY VARCHAR2,
552: x_msg_count OUT NOCOPY NUMBER,
553: x_msg_data OUT NOCOPY VARCHAR2
554: ) ;
555:
556: PROCEDURE create_cust_acct_site (
557: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
558: p_cust_acct_site_tbl IN CUST_ACCT_SITE_TBL_TYPE,
559: x_cust_acct_site_id OUT NOCOPY NUMBER,
560: x_return_status OUT NOCOPY VARCHAR2,
561: x_msg_count OUT NOCOPY NUMBER,
562: x_msg_data OUT NOCOPY VARCHAR2
563: );
564:
565: PROCEDURE update_cust_acct_site (
566: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
567: p_cust_acct_site_tbl IN CUST_ACCT_SITE_TBL_TYPE,
568: p_object_version_number IN OUT NOCOPY NUMBER,
569: x_return_status OUT NOCOPY VARCHAR2,
570: x_msg_count OUT NOCOPY NUMBER,
585: /**** Partial Period Computation Project **/
586:
587: PROCEDURE check_update_amounts (
588: p_api_version IN NUMBER,
589: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
590: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
591: p_chr_id IN NUMBER,
592: x_msg_count OUT NOCOPY NUMBER,
593: x_msg_data OUT NOCOPY VARCHAR2,
586:
587: PROCEDURE check_update_amounts (
588: p_api_version IN NUMBER,
589: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
590: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
591: p_chr_id IN NUMBER,
592: x_msg_count OUT NOCOPY NUMBER,
593: x_msg_data OUT NOCOPY VARCHAR2,
594: x_return_status OUT NOCOPY VARCHAR2